Stored Procedures [dbo].[BAEGetExistingShippingCost]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEGetExistingShippingCost
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@orderNumint4
SQL Script
create procedure [dbo].[BAEGetExistingShippingCost] @orderNum int as
SELECT FREIGHT_1, FREIGHT_2 FROM Orders WHERE ORDER_NUMBER = @orderNum

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved